SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Finally, a lake property that lets you relax. Enjoy the Mascoma Lake lifestyle without many of the maintenance demands and costs often associated with traditional waterfront ownership. This beautifully maintained 3-bedroom, 3-bath home includes access to two shared sandy beaches and conveys with an optional boat slip—allowing owners to keep a boat in the water all season without the hassle of trailering, installing, or removing docks. From peaceful mornings on the lake to evenings on the screened porch listening to loons across the water, this property was designed for enjoying the Upper Valley lifestyle rather than maintaining it. The communities private sandy beach offers a quieter alternative to crowded public areas and creates an ideal setting for swimming, paddleboarding, kayaking, and summer gatherings. Thoughtfully designed for both everyday living and entertaining, the home features a warm and inviting living room with wood-burning fireplace, granite kitchen, flexible first-floor bedroom or office, and seamless access to the screened porch with lake views. Upstairs, the primary suite offers vaulted ceilings, walk-in closet, and private bath, while the walkout lower level provides additional space for recreation, fitness, media, or hobbies. Located just minutes from downtown Lebanon, I-89, Dartmouth Hitchcock Medical Center, Dartmouth College, dining, shopping, and Upper Valley amenities, this property offers a rare combination of lake access, convenience, and low-maintenance enjoyment.
Description:"The Rock Ridge Community" Offering 326 pristine acres of nature, trails, and riverfront access to all that the Upper Valley has to offer. The Upper Valley's Premier Neighborhood, all New Construction. This new home offers over 2,000sf of living space that includes 3 bedroom,3 bath home. Open concept living with hardwood floors, Quartz counter tops, tiled baths, flexible floor plan and many other upgrades including mini splits, kitchen island, gas insert. Share the community garden, enjoy socials at the Farmhouse and the privileges that HOA provides. Close to I-89, DHMC and Dartmouth College, Lebanon 6 Theater, Downtown, and plenty of shopping. Photos show architectural renderings, similar style home and current construction progress. The target finish date is 05/29/2026
Description:Nestled in a desirable residential neighborhood, this well-maintained home offers comfort, character, and versatility. The main level features hardwood floors, a spacious kitchen and bath, 3 bedrooms, a welcoming living room with a wood-burning fireplace, and a lower-level family room. The lower level also includes a 3/4 bath and laundry area, providing flexible additional living space. The rear of the home is designed for relaxation and entertaining, featuring a sunny 3-season porch, back deck, and hot tub overlooking the beautifully landscaped yard, which gently abuts the woods with privacy and a peaceful natural setting. A standout feature is the detached accessory dwelling unit built in 2021 — a thoughtfully designed 1-bedroom, 1-bath bungalow complete with laundry and a private deck, ideal for guests, rental income, extended family, or home office flexibility. New septic system installed in 2021. Conveniently located just one mile from the Lebanon Green, restaurants, the Opera House, library, and post office, with easy access to the Northern Rail Trail, city pool, and Lebanon Middle School.
Description:Welcome to this beautifully updated Cape-style home featuring a two car garage and a level, landscaped yard-perfect for relaxing or entertaining. Thoughtfully designed, this home offers abundant space for family gatherings and special occasions. The stunning kitchen is a chef's dream, complete with stone countertops, a large center island the comfortably seats four, and new stainless steel appliances. Just off the kitchen, the expansive dining room provides ample space for hosting large family dinners. Sunlight pours into the inviting living room, which flows seamlessly into a den with a charming fireplace. A stylish renovated 3/4 bath completes the first floor. Upstairs, you'll find two comfortable guest bedrooms, and a private suite featuring a walk-in closet, private sauna and direst access to a remodeled 3/4 bath. The finished walkout basement offers even more living space with two additional rooms, a generous family room and a third 3/4 bath. With plenty of updates this house is ready for you to make it your home!
Description:Superb location just minutes from Main Street, Hanover and Dartmouth College on desirable Haskins Rd, a quiet dead end street. This 3 bedroom, 2 bath home features a family room with fireplace, dining area and updated kitchen on the main floor with hardwood floors throughout. Upstairs the primary bedroom is situated at the rear of the home with a loft for storage, 2 additional bedrooms, a full bath and a sunny office. Bring your ideas and refresh this cozy contemporary to make it your own while enjoying the peaceful, wooded surroundings. Hiking trails, including the AT, are close by. Conveniently located close to town, schools and short 10 min commute to Dartmouth Health. Showings will begin on Friday BY APPOINTMENT between 3-5 and Saturday BY APPOINTMENT from 11-1.
Description:A sportsman's Paradise! Set on 5.5 private acres in a quiet rural setting, this well-built 2008 log home offers the warmth and character so many buyers are looking for. With 3 bedrooms and soaring cathedral ceilings, cherry and red oak hardwood flooring, the home feels open, comfortable, and connected to its natural surroundings. Recent improvements include a new heating system, adding efficiency and peace of mind. A large wraparound deck creates great outdoor living space for relaxing, entertaining, or taking in the peaceful setting. The property abuts conservation land with established trails, giving you direct access to hiking, snowshoeing, and year-round outdoor recreation right from the backyard. The location offers a nice balance of privacy and convenience, with close proximity to Mascoma Lake, Mt Sunapee, Whaleback, DH Medical Center and all Upper Valley amenities. Whether you're looking for a year-round home or a getaway in New Hampshire, this property captures the classic feel of log home living in a beautiful Enfield setting.
Description:Set on 11.5 private acres in scenic Plainfield, New Hampshire, this beautifully designed 2021 home offers the perfect balance of comfort, privacy, and modern living. The main living area is warm and welcoming, centered around a striking stone hearth with a propane fireplace. The bright kitchen opens seamlessly to the living and dining areas, creating an easy flow for everyday living and entertaining. An oversized 2-car garage offers direct entry into the home, while a dedicated laundry room and half bath are conveniently tucked just off the kitchen. A spacious wraparound deck expands the living space outdoors, providing a peaceful setting for summer dining, relaxing, and enjoying the surrounding landscape and water views. The primary suite features a beautifully appointed en suite bath and walk-in closet. The finished lower level offers a large sauna, flexible space for a gym, office, media room, or additional living area. A whole-house generator adds year-round peace of mind. Surrounded by nature yet conveniently located with easy access to Hanover, Lebanon, Shopping, Dartmouth College, and Dartmouth Hitchcock Medical Center, this property offers a wonderful blend of privacy, convenience, and Upper Valley living. More photos coming soon. Showings start on 5/30/26.
Description:Tucked away on three private, wooded acres, this charming Cape Cod offers the perfect blend of tranquility and efficient home design. The main level features a nicely proportioned living room, an eat-in kitchen, and a family room with a fireplace, plus a convenient half bath. Upstairs, three bedrooms include a spacious primary suite with a full bath, a study perfect for working from home and an additional three-quarter bath. The finished basement adds even more flexibility with a bonus room ready to become a playroom, home gym, or creative space, along with a three-quarter bath. Recent upgrades include a new roof, exterior paint, heat pump technology for efficient cooling, and updated bathrooms throughout. This is a wonderful place to call home.
Description:Located just a half mile south of the Dartmouth Green, this beautifully updated raised ranch offers the perfect blend of comfort, flexibility, and convenience. Tucked on a level, landscaped lot with lawn space and landscaping, the home provides an easy lifestyle in a truly exceptional location, walkable to downtown, schools, dining, and recreation. The thoughtfully designed main level features three bedrooms--one ensuite with a 3/4 bath and two that share an additional full bath. Sunlight fills the welcoming living room, while the adjoining dining area opens seamlessly onto a deck — ideal for morning coffee or summer BBQs. The updated kitchen offers both style and functionality, creating a warm central gathering space for everyday living. The finished lower level adds remarkable versatility, with a large family room centered around a cozy wood stove, perfect for relaxing evenings or casual entertaining. A full bath, laundry room, dedicated office, and smaller bonus room provide flexible spaces to work, create, or host guests with ease. Direct access to the attached one-car garage adds everyday convenience, especially during New England winters. With recent updates, abundant usable space, and an unbeatable in-town setting, this move-in-ready home offers the rare opportunity to enjoy comfort, character, and walkability in the heart of Hanover. Furnished photos are virtually staged.
Description:This waterfront gem has been thoughtfully enhanced with numerous recent improvements, including a newly winterized sunroom that adds 264 square feet of light-filled living space with sweeping water views. The updated exterior façade, new privacy fencing, and improved stairway leading to the private sandy beach and swimming area further elevate the property’s appeal. Offering ~3,000 sq ft across three levels, this home features 2–3 bedrooms, 3½ baths, and flexible living areas. Enter through the generous mudroom into an open-concept kitchen, dining, and living area designed for both everyday comfort and effortless entertaining. This inviting space flows seamlessly into the newly heated, insulated sunroom perched above the water’s edge, where panoramic lake views can be enjoyed year-round. The lower level offers a full bath and two oversized rooms ideal for bedrooms, office, or family space, both with walkout access to the lakeside deck. The lowest level includes a partially finished area, full bath, workshop, and direct walkout waterfront access. Conveniently located near Dartmouth College, Dartmouth Hitchcock Medical Center, and premier ski resorts—this is the ideal year-round lakefront paradise.